Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	17290
Missing cells	7
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.8 MiB
Average record size in memory	168.0 B

Variable types

Numeric	17
DateTime	1
Categorical	3

Alerts

`bathrooms` is highly overall correlated with `bedrooms` and 7 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`floors` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`grade` is highly overall correlated with `bathrooms` and 6 other fields	High correlation
`long` is highly overall correlated with `zipcode`	High correlation
`price` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`sqft_above` is highly overall correlated with `bathrooms` and 6 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_living15` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`zipcode` is highly overall correlated with `long`	High correlation
`waterfront` is highly imbalanced (93.2%)	Imbalance
`view` is highly imbalanced (71.8%)	Imbalance
`sqft_basement` has 10480 (60.6%) zeros	Zeros
`yr_renovated` has 16533 (95.6%) zeros	Zeros

Reproduction

Analysis started	2025-10-02 20:00:03.166027
Analysis finished	2025-10-02 20:00:37.956071
Duration	34.79 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

id
Real number (ℝ)

Distinct	17169
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5644764 × 10⁹

Minimum	1000102
Maximum	9.895 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	1000102
5-th percentile	5.2204911 × 10⁸
Q1	2.1254 × 10⁹
median	3.9023003 × 10⁹
Q3	7.2979251 × 10⁹
95-th percentile	9.290856 × 10⁹
Maximum	9.895 × 10⁹
Range	9.8939999 × 10⁹
Interquartile range (IQR)	5.172525 × 10⁹

Descriptive statistics

Standard deviation	2.864976 × 10⁹
Coefficient of variation (CV)	0.62766806
Kurtosis	-1.2463349
Mean	4.5644764 × 10⁹
Median Absolute Deviation (MAD)	2.3772411 × 10⁹
Skewness	0.25565765
Sum	7.8919796 × 10¹³
Variance	8.2080876 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
302000375	2	< 0.1%
7504021310	2	< 0.1%
4222310010	2	< 0.1%
2767603612	2	< 0.1%
5083000375	2	< 0.1%
1250201165	2	< 0.1%
9407110710	2	< 0.1%
3262300940	2	< 0.1%
9222400605	2	< 0.1%
7888000390	2	< 0.1%
Other values (17159)	17270	99.9%

Value	Count	Frequency (%)
1000102	2	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
7200080	1	< 0.1%

Value	Count	Frequency (%)
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300036	1	< 0.1%
9839301165	1	< 0.1%
9839301060	1	< 0.1%
9839301055	1	< 0.1%
9839300875	1	< 0.1%
9839300775	1	< 0.1%
9839300545	1	< 0.1%

date
Date

Distinct	369
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	135.2 KiB

Minimum	2014-05-02 00:00:00
Maximum	2015-05-27 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

High correlation

Distinct	3562
Distinct (%)	20.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	542799.84

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	75000
5-th percentile	210500
Q1	324000
median	453000
Q3	647500
95-th percentile	1175000
Maximum	7700000
Range	7625000
Interquartile range (IQR)	323500

Descriptive statistics

Standard deviation	372439.03
Coefficient of variation (CV)	0.68614432
Kurtosis	36.366127
Mean	542799.84
Median Absolute Deviation (MAD)	152000
Skewness	4.1293833
Sum	9.3850092 × 10⁹
Variance	1.3871083 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350000	134	0.8%
450000	131	0.8%
550000	127	0.7%
425000	124	0.7%
500000	124	0.7%
325000	118	0.7%
375000	113	0.7%
400000	112	0.6%
250000	107	0.6%
650000	102	0.6%
Other values (3552)	16098	93.1%

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
86500	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7062500	1	< 0.1%
6885000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110800	1	< 0.1%
4668000	1	< 0.1%
4500000	1	< 0.1%
4489000	1	< 0.1%
4000000	1	< 0.1%

bedrooms
Real number (ℝ)

High correlation

Distinct	13
Distinct (%)	0.1%
Missing	7
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.3680495

Minimum	0
Maximum	33
Zeros	11
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.94311768
Coefficient of variation (CV)	0.28001894
Kurtosis	57.730327
Mean	3.3680495
Median Absolute Deviation (MAD)	1
Skewness	2.2710443
Sum	58210
Variance	0.88947095
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	7830	45.3%
4	5437	31.4%
2	2257	13.1%
5	1307	7.6%
6	225	1.3%
1	166	1.0%
7	32	0.2%
0	11	0.1%
8	8	< 0.1%
9	5	< 0.1%
Other values (3)	5	< 0.1%
(Missing)	7	< 0.1%

Value	Count	Frequency (%)
0	11	0.1%
1	166	1.0%
2	2257	13.1%
3	7830	45.3%
4	5437	31.4%
5	1307	7.6%
6	225	1.3%
7	32	0.2%
8	8	< 0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	5	< 0.1%
8	8	< 0.1%
7	32	0.2%
6	225	1.3%
5	1307	7.6%
4	5437	31.4%
3	7830	45.3%

bathrooms
Real number (ℝ)

High correlation

Distinct	30
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1182909

Minimum	0
Maximum	8
Zeros	9
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	8
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.77224948
Coefficient of variation (CV)	0.36456252
Kurtosis	1.3422932
Mean	2.1182909
Median Absolute Deviation (MAD)	0.5
Skewness	0.51556976
Sum	36625.25
Variance	0.59636925
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
2.5	4309	24.9%
1	3070	17.8%
1.75	2438	14.1%
2.25	1609	9.3%
2	1549	9.0%
1.5	1147	6.6%
2.75	972	5.6%
3.5	610	3.5%
3	589	3.4%
3.25	468	2.7%
Other values (20)	529	3.1%

Value	Count	Frequency (%)
0	9	0.1%
0.5	3	< 0.1%
0.75	57	0.3%
1	3070	17.8%
1.25	8	< 0.1%
1.5	1147	6.6%
1.75	2438	14.1%
2	1549	9.0%
2.25	1609	9.3%
2.5	4309	24.9%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	3	< 0.1%
5.75	1	< 0.1%
5.5	9	0.1%
5.25	8	< 0.1%

sqft_living
Real number (ℝ)

High correlation

Distinct	942
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2081.4167

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	290
5-th percentile	930
Q1	1420
median	1920
Q3	2550
95-th percentile	3780
Maximum	13540
Range	13250
Interquartile range (IQR)	1130

Descriptive statistics

Standard deviation	923.24458
Coefficient of variation (CV)	0.44356547
Kurtosis	5.5925159
Mean	2081.4167
Median Absolute Deviation (MAD)	550
Skewness	1.49953
Sum	35987695
Variance	852380.55
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1400	118	0.7%
1440	112	0.6%
1800	110	0.6%
1300	106	0.6%
1010	103	0.6%
1560	101	0.6%
1540	100	0.6%
1660	98	0.6%
1320	96	0.6%
1820	96	0.6%
Other values (932)	16250	94.0%

Value	Count	Frequency (%)
290	1	< 0.1%
380	1	< 0.1%
390	2	< 0.1%
420	1	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%
470	1	< 0.1%
480	2	< 0.1%
490	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%
7880	1	< 0.1%

sqft_lot
Real number (ℝ)

High correlation

Distinct	8431
Distinct (%)	48.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15241.884

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	520
5-th percentile	1750
Q1	5033.25
median	7588.5
Q3	10713
95-th percentile	43560
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5679.75

Descriptive statistics

Standard deviation	42270.28
Coefficient of variation (CV)	2.7732975
Kurtosis	277.26071
Mean	15241.884
Median Absolute Deviation (MAD)	2626.5
Skewness	12.86597
Sum	2.6353218 × 10⁸
Variance	1.7867766 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	297	1.7%
6000	243	1.4%
4000	200	1.2%
7200	176	1.0%
4800	100	0.6%
4500	95	0.5%
7500	84	0.5%
3600	84	0.5%
8400	82	0.5%
9600	81	0.5%
Other values (8421)	15848	91.7%

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%
715690	1	< 0.1%
641203	1	< 0.1%

floors
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4980625

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.54260257
Coefficient of variation (CV)	0.3622029
Kurtosis	-0.46267765
Mean	1.4980625
Median Absolute Deviation (MAD)	0.5
Skewness	0.62117792
Sum	25901.5
Variance	0.29441755
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	8496	49.1%
2	6588	38.1%
1.5	1549	9.0%
3	513	3.0%
2.5	137	0.8%
3.5	7	< 0.1%

Value	Count	Frequency (%)
1	8496	49.1%
1.5	1549	9.0%
2	6588	38.1%
2.5	137	0.8%
3	513	3.0%
3.5	7	< 0.1%

Value	Count	Frequency (%)
3.5	7	< 0.1%
3	513	3.0%
2.5	137	0.8%
2	6588	38.1%
1.5	1549	9.0%
1	8496	49.1%

waterfront
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.2 KiB

0	17149
1	141

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17290
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	17149	99.2%
1	141	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	17149	99.2%
1	141	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	17149	99.2%
1	141	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	17149	99.2%
1	141	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	17149	99.2%
1	141	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	17149	99.2%
1	141	0.8%

view
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.2 KiB

0	15557
2	788
3	406
1	278
4	261

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17290
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15557	90.0%
2	788	4.6%
3	406	2.3%
1	278	1.6%
4	261	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	15557	90.0%
2	788	4.6%
3	406	2.3%
1	278	1.6%
4	261	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	15557	90.0%
2	788	4.6%
3	406	2.3%
1	278	1.6%
4	261	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	15557	90.0%
2	788	4.6%
3	406	2.3%
1	278	1.6%
4	261	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	15557	90.0%
2	788	4.6%
3	406	2.3%
1	278	1.6%
4	261	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	15557	90.0%
2	788	4.6%
3	406	2.3%
1	278	1.6%
4	261	1.5%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.2 KiB

3	11259
4	4513
5	1354
2	139
1	25

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17290
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	3
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
3	11259	65.1%
4	4513	26.1%
5	1354	7.8%
2	139	0.8%
1	25	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	11259	65.1%
4	4513	26.1%
5	1354	7.8%
2	139	0.8%
1	25	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	11259	65.1%
4	4513	26.1%
5	1354	7.8%
2	139	0.8%
1	25	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	11259	65.1%
4	4513	26.1%
5	1354	7.8%
2	139	0.8%
1	25	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	11259	65.1%
4	4513	26.1%
5	1354	7.8%
2	139	0.8%
1	25	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17290	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	11259	65.1%
4	4513	26.1%
5	1354	7.8%
2	139	0.8%
1	25	0.1%

grade
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6600347

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1764281
Coefficient of variation (CV)	0.15358
Kurtosis	1.2207208
Mean	7.6600347
Median Absolute Deviation (MAD)	1
Skewness	0.76483861
Sum	132442
Variance	1.3839831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	7137	41.3%
8	4910	28.4%
9	2090	12.1%
6	1623	9.4%
10	896	5.2%
11	331	1.9%
5	196	1.1%
12	68	0.4%
4	23	0.1%
13	12	0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	23	0.1%
5	196	1.1%
6	1623	9.4%
7	7137	41.3%
8	4910	28.4%
9	2090	12.1%
10	896	5.2%
11	331	1.9%

Value	Count	Frequency (%)
13	12	0.1%
12	68	0.4%
11	331	1.9%
10	896	5.2%
9	2090	12.1%
8	4910	28.4%
7	7137	41.3%
6	1623	9.4%
5	196	1.1%
4	23	0.1%

sqft_above
Real number (ℝ)

High correlation

Distinct	853
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1788.2996

Minimum	290
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	290
5-th percentile	840
Q1	1190
median	1560
Q3	2210
95-th percentile	3415.5
Maximum	9410
Range	9120
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	831.88962
Coefficient of variation (CV)	0.4651847
Kurtosis	3.5376648
Mean	1788.2996
Median Absolute Deviation (MAD)	450
Skewness	1.4686636
Sum	30919700
Variance	692040.33
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1010	172	1.0%
1300	162	0.9%
1200	160	0.9%
1340	147	0.9%
1400	147	0.9%
1220	146	0.8%
1180	142	0.8%
1140	140	0.8%
1060	139	0.8%
1320	138	0.8%
Other values (843)	15797	91.4%

Value	Count	Frequency (%)
290	1	< 0.1%
380	1	< 0.1%
390	2	< 0.1%
420	1	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%
470	1	< 0.1%
480	3	< 0.1%
490	2	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7680	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%
6640	1	< 0.1%
6530	1	< 0.1%

sqft_basement
Real number (ℝ)

Zeros

Distinct	282
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	293.11712

Minimum	0
Maximum	4820
Zeros	10480
Zeros (%)	60.6%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	570
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	570

Descriptive statistics

Standard deviation	443.63039
Coefficient of variation (CV)	1.5134919
Kurtosis	2.8444243
Mean	293.11712
Median Absolute Deviation (MAD)	0
Skewness	1.5809084
Sum	5067995
Variance	196807.92
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10480	60.6%
600	180	1.0%
700	179	1.0%
500	177	1.0%
800	157	0.9%
400	145	0.8%
1000	122	0.7%
900	114	0.7%
300	109	0.6%
720	87	0.5%
Other values (272)	5540	32.0%

Value	Count	Frequency (%)
0	10480	60.6%
10	1	< 0.1%
20	1	< 0.1%
40	2	< 0.1%
50	10	0.1%
60	7	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	19	0.1%
90	18	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
2850	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%
2600	1	< 0.1%
2590	1	< 0.1%

yr_built
Real number (ℝ)

High correlation

Distinct	116
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1970.9642

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.485431
Coefficient of variation (CV)	0.014959902
Kurtosis	-0.65930366
Mean	1970.9642
Median Absolute Deviation (MAD)	23
Skewness	-0.47006591
Sum	34077971
Variance	869.39064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	450	2.6%
2006	361	2.1%
2005	358	2.1%
2003	347	2.0%
2004	341	2.0%
1977	341	2.0%
2007	328	1.9%
1968	315	1.8%
1978	309	1.8%
2008	295	1.7%
Other values (106)	13845	80.1%

Value	Count	Frequency (%)
1900	73	0.4%
1901	23	0.1%
1902	22	0.1%
1903	41	0.2%
1904	40	0.2%
1905	57	0.3%
1906	83	0.5%
1907	55	0.3%
1908	63	0.4%
1909	76	0.4%

Value	Count	Frequency (%)
2015	35	0.2%
2014	450	2.6%
2013	168	1.0%
2012	145	0.8%
2011	107	0.6%
2010	114	0.7%
2009	189	1.1%
2008	295	1.7%
2007	328	1.9%
2006	361	2.1%

yr_renovated
Real number (ℝ)

Zeros

Distinct	67
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	87.387681

Minimum	0
Maximum	2015
Zeros	16533
Zeros (%)	95.6%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	408.4174
Coefficient of variation (CV)	4.6736267
Kurtosis	17.897003
Mean	87.387681
Median Absolute Deviation (MAD)	0
Skewness	4.4602088
Sum	1510933
Variance	166804.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16533	95.6%
2014	73	0.4%
2013	33	0.2%
2007	31	0.2%
2000	30	0.2%
2005	28	0.2%
2003	28	0.2%
2004	22	0.1%
2009	22	0.1%
1990	20	0.1%
Other values (57)	470	2.7%

Value	Count	Frequency (%)
0	16533	95.6%
1940	1	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	2	< 0.1%
1950	1	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%
1954	1	< 0.1%
1955	2	< 0.1%

Value	Count	Frequency (%)
2015	13	0.1%
2014	73	0.4%
2013	33	0.2%
2012	11	0.1%
2011	11	0.1%
2010	15	0.1%
2009	22	0.1%
2008	16	0.1%
2007	31	0.2%
2006	15	0.1%

zipcode
Real number (ℝ)

High correlation

Distinct	70
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.935

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98117
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	53.505656
Coefficient of variation (CV)	0.00054554223
Kurtosis	-0.85391584
Mean	98077.935
Median Absolute Deviation (MAD)	42
Skewness	0.40020502
Sum	1.6957675 × 10⁹
Variance	2862.8552
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	485	2.8%
98038	478	2.8%
98052	458	2.6%
98115	458	2.6%
98117	449	2.6%
98034	437	2.5%
98042	422	2.4%
98118	404	2.3%
98006	404	2.3%
98133	394	2.3%
Other values (60)	12901	74.6%

Value	Count	Frequency (%)
98001	299	1.7%
98002	152	0.9%
98003	224	1.3%
98004	264	1.5%
98005	135	0.8%
98006	404	2.3%
98007	111	0.6%
98008	230	1.3%
98010	83	0.5%
98011	153	0.9%

Value	Count	Frequency (%)
98199	259	1.5%
98198	227	1.3%
98188	103	0.6%
98178	197	1.1%
98177	208	1.2%
98168	204	1.2%
98166	203	1.2%
98155	360	2.1%
98148	47	0.3%
98146	210	1.2%

lat
Real number (ℝ)

Distinct	4846
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560451

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.309645
Q1	47.4724
median	47.5731
Q3	47.6779
95-th percentile	47.7494
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.2055

Descriptive statistics

Standard deviation	0.1386244
Coefficient of variation (CV)	0.0029146989
Kurtosis	-0.65607053
Mean	47.560451
Median Absolute Deviation (MAD)	0.1038
Skewness	-0.50058647
Sum	822320.2
Variance	0.019216723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.6711	16	0.1%
47.5491	15	0.1%
47.5322	14	0.1%
47.6844	14	0.1%
47.6374	14	0.1%
47.6904	14	0.1%
47.686	14	0.1%
47.6647	13	0.1%
47.5427	13	0.1%
47.6842	13	0.1%
Other values (4836)	17150	99.2%

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	1	< 0.1%
47.1795	1	< 0.1%
47.1808	1	< 0.1%
47.184	1	< 0.1%
47.1853	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	2	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7767	4	< 0.1%
47.7766	4	< 0.1%
47.7765	3	< 0.1%

long
Real number (ℝ)

High correlation

Distinct	723
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.21419

Minimum	-122.514
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	17290
Negative (%)	100.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	-122.514
5-th percentile	-122.387
Q1	-122.328
median	-122.2315
Q3	-122.125
95-th percentile	-121.98
Maximum	-121.315
Range	1.199
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14074546
Coefficient of variation (CV)	-0.0011516294
Kurtosis	1.0205698
Mean	-122.21419
Median Absolute Deviation (MAD)	0.1015
Skewness	0.88156052
Sum	-2113083.4
Variance	0.019809284
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	92	0.5%
-122.362	88	0.5%
-122.3	85	0.5%
-122.372	82	0.5%
-122.291	80	0.5%
-122.304	78	0.5%
-122.375	78	0.5%
-122.299	77	0.4%
-122.288	77	0.4%
-122.284	77	0.4%
Other values (713)	16476	95.3%

Value	Count	Frequency (%)
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	1	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	2	< 0.1%
-122.504	2	< 0.1%
-122.503	2	< 0.1%
-122.502	1	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	1	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%
-121.405	1	< 0.1%
-121.417	1	< 0.1%

sqft_living15
Real number (ℝ)

High correlation

Distinct	713
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1987.4751

Minimum	399
Maximum	6110
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2360
95-th percentile	3300
Maximum	6110
Range	5711
Interquartile range (IQR)	870

Descriptive statistics

Standard deviation	686.25538
Coefficient of variation (CV)	0.34529006
Kurtosis	1.5683662
Mean	1987.4751
Median Absolute Deviation (MAD)	410
Skewness	1.1057171
Sum	34363444
Variance	470946.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	160	0.9%
1440	158	0.9%
1560	153	0.9%
1500	149	0.9%
1720	140	0.8%
1580	139	0.8%
1800	134	0.8%
1610	132	0.8%
1760	130	0.8%
1470	129	0.7%
Other values (703)	15866	91.8%

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
690	1	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	1	< 0.1%
740	6	< 0.1%
750	2	< 0.1%
760	2	< 0.1%

Value	Count	Frequency (%)
6110	1	< 0.1%
5790	5	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%
5200	1	< 0.1%
5110	1	< 0.1%

sqft_lot15
Real number (ℝ)

High correlation

Distinct	7569
Distinct (%)	43.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12834.458

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	135.2 KiB

Quantile statistics

Minimum	651
5-th percentile	1929.15
Q1	5100
median	7619
Q3	10099.5
95-th percentile	37038.4
Maximum	871200
Range	870549
Interquartile range (IQR)	4999.5

Descriptive statistics

Standard deviation	27766.935
Coefficient of variation (CV)	2.1634676
Kurtosis	162.92897
Mean	12834.458
Median Absolute Deviation (MAD)	2518
Skewness	9.8139161
Sum	2.2190779 × 10⁸
Variance	7.7100266 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	348	2.0%
4000	293	1.7%
6000	249	1.4%
7200	165	1.0%
4800	115	0.7%
7500	113	0.7%
3600	95	0.5%
8400	93	0.5%
4500	90	0.5%
5100	82	0.5%
Other values (7559)	15647	90.5%

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	1	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
809	1	< 0.1%
810	2	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
380279	1	< 0.1%
360000	1	< 0.1%

Interactions

Correlations

	bathrooms	bedrooms	condition	floors	grade	id	lat	long	price	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	yr_renovated	zipcode
bathrooms	1.000	0.525	0.131	0.544	0.659	0.017	0.011	0.260	0.500	0.690	0.195	0.744	0.566	0.067	0.061	0.120	0.121	0.562	0.049	-0.203
bedrooms	0.525	1.000	0.025	0.228	0.383	0.007	-0.019	0.196	0.353	0.544	0.237	0.653	0.447	0.215	0.199	0.038	0.000	0.180	0.024	-0.171
condition	0.131	0.025	1.000	0.182	0.164	0.029	0.055	0.084	0.020	0.109	0.096	0.060	0.061	0.011	0.010	0.026	0.024	0.251	0.068	0.076
floors	0.544	0.228	0.182	1.000	0.503	0.021	0.027	0.143	0.324	0.597	-0.275	0.396	0.298	-0.236	-0.234	0.025	0.025	0.550	0.020	-0.057
grade	0.659	0.383	0.164	0.503	1.000	0.024	0.104	0.223	0.657	0.709	0.095	0.714	0.656	0.149	0.155	0.146	0.127	0.502	0.021	-0.180
id	0.017	0.007	0.029	0.021	0.024	1.000	-0.004	0.010	0.007	0.007	0.002	0.004	0.000	-0.111	-0.110	0.028	0.011	0.025	-0.016	-0.007
lat	0.011	-0.019	0.055	0.027	0.104	-0.004	1.000	-0.151	0.451	-0.026	0.115	0.031	0.027	-0.129	-0.120	0.068	0.034	-0.122	0.026	0.255
long	0.260	0.196	0.084	0.143	0.223	0.010	-0.151	1.000	0.060	0.387	-0.194	0.288	0.382	0.378	0.382	0.078	0.089	0.410	-0.073	-0.583
price	0.500	0.353	0.020	0.324	0.657	0.007	0.451	0.060	1.000	0.543	0.254	0.645	0.572	0.071	0.060	0.216	0.336	0.101	0.106	-0.007
sqft_above	0.690	0.544	0.109	0.597	0.709	0.007	-0.026	0.387	0.543	1.000	-0.161	0.844	0.694	0.277	0.259	0.094	0.099	0.466	0.040	-0.280
sqft_basement	0.195	0.237	0.096	-0.275	0.095	0.002	0.115	-0.194	0.254	-0.161	1.000	0.332	0.137	0.037	0.032	0.164	0.144	-0.177	0.062	0.109
sqft_living	0.744	0.653	0.060	0.396	0.714	0.004	0.031	0.288	0.645	0.844	0.332	1.000	0.746	0.308	0.289	0.157	0.156	0.347	0.060	-0.211
sqft_living15	0.566	0.447	0.061	0.298	0.656	0.000	0.027	0.382	0.572	0.694	0.137	0.746	1.000	0.365	0.372	0.151	0.096	0.328	-0.001	-0.288
sqft_lot	0.067	0.215	0.011	-0.236	0.149	-0.111	-0.129	0.378	0.071	0.277	0.037	0.308	0.365	1.000	0.924	0.046	0.015	-0.040	0.012	-0.329
sqft_lot15	0.061	0.199	0.010	-0.234	0.155	-0.110	-0.120	0.382	0.060	0.259	0.032	0.289	0.372	0.924	1.000	0.037	0.000	-0.017	0.010	-0.336
view	0.120	0.038	0.026	0.025	0.146	0.028	0.068	0.078	0.216	0.094	0.164	0.157	0.151	0.046	0.037	1.000	0.614	0.042	0.111	0.075
waterfront	0.121	0.000	0.024	0.025	0.127	0.011	0.034	0.089	0.336	0.099	0.144	0.156	0.096	0.015	0.000	0.614	1.000	0.033	0.092	0.082
yr_built	0.562	0.180	0.251	0.550	0.502	0.025	-0.122	0.410	0.101	0.466	-0.177	0.347	0.328	-0.040	-0.017	0.042	0.033	1.000	-0.216	-0.312
yr_renovated	0.049	0.024	0.068	0.020	0.021	-0.016	0.026	-0.073	0.106	0.040	0.062	0.060	-0.001	0.012	0.010	0.111	0.092	-0.216	1.000	0.062
zipcode	-0.203	-0.171	0.076	-0.057	-0.180	-0.007	0.255	-0.583	-0.007	-0.280	0.109	-0.211	-0.288	-0.329	-0.336	0.075	0.082	-0.312	0.062	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	view	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15
0	5100402668	20150218T000000	495000.0	3.0	1.00	1570	5510	1.0	0	4	7	1070	500	1940	98115	47.6942	-122.319	1770	6380
1	7856560480	20140808T000000	635000.0	3.0	2.50	1780	11000	1.0	0	4	8	1210	570	1980	98006	47.5574	-122.149	2310	9700
2	2872900010	20150414T000000	382500.0	3.0	1.50	1090	9862	1.0	0	3	8	1090	0	1987	98074	47.6256	-122.036	1710	9862
3	3216900070	20140617T000000	382500.0	4.0	2.50	2210	7079	2.0	0	3	8	2210	0	1993	98031	47.4206	-122.183	1970	7000
4	976000790	20141020T000000	670000.0	3.0	2.50	1800	4763	2.0	0	3	7	1240	560	1985	98119	47.6460	-122.362	1790	4763
5	6815100085	20141224T000000	1001000.0	4.0	2.00	3100	8000	1.5	0	5	7	2040	1060	1939	98103	47.6852	-122.329	1650	4000
6	7237550020	20140703T000000	1100000.0	4.0	3.75	5070	60123	2.0	0	3	11	5070	0	2000	98053	47.6567	-122.004	4920	101930
7	1231000310	20140812T000000	713000.0	1.0	1.00	1180	4000	1.5	2	4	8	840	340	1910	98118	47.5561	-122.266	1420	4000
8	8663260030	20141118T000000	416000.0	3.0	2.50	1800	5372	2.0	0	3	8	1800	0	1987	98034	47.7188	-122.177	1650	6014
9	1160000115	20150304T000000	401000.0	4.0	1.75	3010	12523	1.0	0	3	8	1780	1230	1952	98125	47.7070	-122.316	2040	7560

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15
17280	6738700005	20140529T000000	395000.0	2.0	1.00	1320	1824	1.5	4	6	1320	0	1909	98144	47.5850	-122.294	1320	4000
17281	2902200915	20141125T000000	675000.0	3.0	1.75	2130	4400	1.0	3	7	1430	700	1922	98102	47.6417	-122.325	1710	3300
17282	3022900070	20140929T000000	348000.0	3.0	2.00	2360	6145	1.0	3	8	2360	0	2011	98030	47.3564	-122.198	2304	5880
17283	6917700195	20140728T000000	585000.0	3.0	1.75	1480	4800	2.0	4	7	1140	340	1944	98199	47.6567	-122.397	1810	4800
17284	1105000402	20141028T000000	630000.0	4.0	3.00	3640	5096	2.0	3	8	2740	900	2010	98118	47.5428	-122.270	1910	9189
17285	2322069010	20141007T000000	1180000.0	5.0	5.00	3960	94089	2.0	3	10	3960	0	1998	98038	47.3800	-122.011	2240	64468
17286	2114700368	20141118T000000	299000.0	2.0	2.50	1400	1262	2.0	3	8	1160	240	2008	98106	47.5342	-122.349	1060	1524
17287	5469501200	20140820T000000	431000.0	3.0	2.25	2360	14950	1.0	4	9	2360	0	1978	98042	47.3856	-122.158	2720	14388
17288	3751602797	20140702T000000	411000.0	4.0	2.00	2370	76665	2.0	4	8	2370	0	1978	98001	47.2831	-122.279	2110	19334
17289	4038600260	20140922T000000	699900.0	4.0	2.25	2380	16236	1.0	3	7	1540	840	1961	98008	47.6126	-122.120	2230	8925

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample